if (
    isNull(TRAIT_STORE_NBR) && 
    isNull(RETAIL_TYPE)
    && isNull(NEW_RETAIL_EFF_DATE)
    && isNull(NEW_RETAIL_EXP_DATE)
    && isNull(NEW_RETAIL)) {
    '{"CODE":0, "ACTION":"","LEVEL":"", "MSG":"","DATA":""}';
} else if (
    isNull(TRAIT_STORE_NBR) || 
    isNull(RETAIL_TYPE)
    || isNull(NEW_RETAIL_EFF_DATE)
    || isNull(NEW_RETAIL_EXP_DATE)
    || isNull(NEW_RETAIL)) {
    '{"CODE":2, "ACTION":"CHECKING_REPORT","LEVEL":"", "MSG":"零售变价信息(发送特征，变价类型，新零售生效日，新零售结束日)填写不完整","DATA":""}';
} else {
    '{"CODE":0, "ACTION":"","LEVEL":"", "MSG":"","DATA":""}';
}